package com.nbsaas.boot;

import com.nbsaas.boot.sql.SqlUtils;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.statement.Statement;
import net.sf.jsqlparser.statement.select.PlainSelect;
import net.sf.jsqlparser.statement.select.Select;

public class SqlApp {

    public static void main(String[] args) throws JSQLParserException {

        String sql = "SELECT id, name FROM users WHERE status = 1 ORDER BY name DESC, id ASC";

        System.out.println(SqlUtils.clearOrderBy( sql));
    }
}
